<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<title>SprintTable xref</title>
<link type="text/css" rel="stylesheet" href="../../../../../stylesheet.css" />
</head>
<body>
<div id="overview"><a href="../../../../../../apidocs/org/inftel/ssa/mobile/contentproviders/SprintTable.html">View Javadoc</a></div><pre>

<a class="jxr_linenumber" name="1" href="#1">1</a>   
<a class="jxr_linenumber" name="2" href="#2">2</a>   <strong class="jxr_keyword">package</strong> org.inftel.ssa.mobile.contentproviders;
<a class="jxr_linenumber" name="3" href="#3">3</a>   
<a class="jxr_linenumber" name="4" href="#4">4</a>   <strong class="jxr_keyword">import</strong> android.database.sqlite.SQLiteDatabase;
<a class="jxr_linenumber" name="5" href="#5">5</a>   <strong class="jxr_keyword">import</strong> android.util.Log;
<a class="jxr_linenumber" name="6" href="#6">6</a>   
<a class="jxr_linenumber" name="7" href="#7">7</a>   <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../org/inftel/ssa/mobile/contentproviders/SprintTable.html">SprintTable</a> {
<a class="jxr_linenumber" name="8" href="#8">8</a>   
<a class="jxr_linenumber" name="9" href="#9">9</a>       <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String TAG = <span class="jxr_string">"SprintTable"</span>;
<a class="jxr_linenumber" name="10" href="#10">10</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String SPRINT_TABLE = <span class="jxr_string">"sprints"</span>;
<a class="jxr_linenumber" name="11" href="#11">11</a>  
<a class="jxr_linenumber" name="12" href="#12">12</a>      <em class="jxr_comment">// Database table</em>
<a class="jxr_linenumber" name="13" href="#13">13</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String KEY_ID = <span class="jxr_string">"_id"</span>;
<a class="jxr_linenumber" name="14" href="#14">14</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String KEY_SUMMARY = <span class="jxr_string">"summary"</span>;
<a class="jxr_linenumber" name="15" href="#15">15</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String KEY_STABLE_ID = <span class="jxr_string">"stable_id"</span>;
<a class="jxr_linenumber" name="16" href="#16">16</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String KEY_PROJECT_FK = <span class="jxr_string">"project_id"</span>;
<a class="jxr_linenumber" name="17" href="#17">17</a>  
<a class="jxr_linenumber" name="18" href="#18">18</a>      <em class="jxr_comment">// Database creation sql statement</em>
<a class="jxr_linenumber" name="19" href="#19">19</a>      <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> String DATABASE_CREATE =
<a class="jxr_linenumber" name="20" href="#20">20</a>              <span class="jxr_string">"create table "</span> + SPRINT_TABLE + <span class="jxr_string">" ("</span>
<a class="jxr_linenumber" name="21" href="#21">21</a>                      + KEY_ID + <span class="jxr_string">" INTEGER primary key autoincrement, "</span>
<a class="jxr_linenumber" name="22" href="#22">22</a>                      + KEY_SUMMARY + <span class="jxr_string">" TEXT, "</span>
<a class="jxr_linenumber" name="23" href="#23">23</a>                      + KEY_STABLE_ID + <span class="jxr_string">" TEXT, "</span>
<a class="jxr_linenumber" name="24" href="#24">24</a>                      + KEY_PROJECT_FK + <span class="jxr_string">" INTEGER); "</span>;
<a class="jxr_linenumber" name="25" href="#25">25</a>  
<a class="jxr_linenumber" name="26" href="#26">26</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">void</strong> onCreate(SQLiteDatabase database) {
<a class="jxr_linenumber" name="27" href="#27">27</a>          database.execSQL(DATABASE_CREATE);
<a class="jxr_linenumber" name="28" href="#28">28</a>      }
<a class="jxr_linenumber" name="29" href="#29">29</a>  
<a class="jxr_linenumber" name="30" href="#30">30</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">void</strong> onUpgrade(SQLiteDatabase db, <strong class="jxr_keyword">int</strong> oldVersion, <strong class="jxr_keyword">int</strong> newVersion) {
<a class="jxr_linenumber" name="31" href="#31">31</a>          Log.w(TAG, <span class="jxr_string">"Upgrading database from version "</span> + oldVersion + <span class="jxr_string">" to "</span>
<a class="jxr_linenumber" name="32" href="#32">32</a>                  + newVersion + <span class="jxr_string">", which will destroy all old data"</span>);
<a class="jxr_linenumber" name="33" href="#33">33</a>          db.execSQL(<span class="jxr_string">"DROP TABLE IF EXISTS "</span> + SPRINT_TABLE);
<a class="jxr_linenumber" name="34" href="#34">34</a>          onCreate(db);
<a class="jxr_linenumber" name="35" href="#35">35</a>      }
<a class="jxr_linenumber" name="36" href="#36">36</a>  }
</pre>
<hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body>
</html>

